A survey by the Royal College of Nursing found ‘harrowing’ examples of vulnerable patients being treated in corridors